Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Customer Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Help Center (docs.oracle.com)
• Conventions

1 Introduction to RICS on APEX

• What is APEX?
• Need for RICS on APEX
• Functionality Offered
• Accessibility
  • What is Web Accessibility?
  • Principles of Accessibility
  • Why Accessibility is Important
  • About Building for Accessibility

2 Basic Functions of APEX

• Adding Users to a Workspace
  • Create a New User
  • Create Multiple Users
• Querying Data
  • Viewing Tables
  • Describe Tables
  • Query Table Data

3 Introduction to Dynamic Data Services (DDS)

• What is DDS?
• Need for DDS
• Functionality Offered
• Accessibility

4 DDS Installation Prerequisites

• Installation and Setup Instructions
  • Prerequisites
• Installing WebLogic
• Creating the Required Schema Using Repository Creation Utility
• Creating a WebLogic Domain with JRF

5 Deploying DDS Web Application

• Preparing the Database for DDS Installation
• Deploying DDS Web Application on the WebLogic Servers
• Redeploying DDS Web Application
• Testing the Deployment

6 DDS Security

• Access Levels
• Table Level Security
• Column Level Security
• Row Level Security
• Security Setup
• System Options

7 DDS RESTful Services

• Discover
• Get Data
• Get Data from a Table
• Insert Data
• Update Data
• Delete Data
• Get Schemas
• Get Tables
• Get Columns for a Table
• Get System Options
• Create System Options
• Update System Options
• Delete System Options
• Reset Cache

8 DDS Security RESTful Services

• Get Security Groups
• Get Security Group Permissions
• Get Access Levels
• Get Security Config for a Schema
• Get All Security Config
• Get All Table Level Securities
• Get Table Level Security for Table
• Get Table Level Security for Table and Group
• Get Column Level Security for Table and Group
• Get Row Level Security for Table and Group
• Create Access Level
• Update Access Level
• Delete Access Level
• Create Table Level Security
• Create Table Level Securities
• Update Table Level Security
• Update Table Level Securities
• Delete Table Level Security
• Delete Table Level Security by Id
• Delete Table Level Securities by Type
• Create Column Level Security
• Update Column Level Security
• Delete Column Level Security
• Create Data Security Configuration
• Update Data Security Configuration
• Delete Data Security Configuration
• Create Security Group
• Delete Security Group
• Create Row Level Security
• Update Row Level Security
• Delete Row Level Security
• Create Default Security Setup

9 DDS User Interface

• Admin Tab Guide
  • Initial Permissions Setup
  • Manage Access Levels
  • Manage Security Groups
  • Manage Security Permissions
• Designer Tab Guide
  • Table Definition
  • Query Builder

10 DDS Advanced Backend Features

• LIKE Statement
• IN Statement
• Comparative Operators
• Filtering DATE Column
• Combinations of OR, AND & BETWEEN Statements
• Viewing Clob Data
• Viewing Query Response as JSON Data
• JOINing Two or More Tables
• Count of Records